Using Queries
A query in HAMMER CONNECT is a user-defined SQL expression that applies to a single element type. You use the Query Manager to create and store queries; you use the Query Builder dialog box to construct the actual SQL expression.
Queries can be one of the following three types:
- Hydraulic Model queries—Queries you define that are available only in the HAMMER CONNECT hydraulic model in which you define them.
- Shared queries—Queries you define that are available in all HAMMER CONNECT hydraulic models you create. You can edit shared queries.
- Predefined queries—Factory-defined queries included with HAMMER CONNECT that are available in all hydraulic models you create. You cannot edit predefined queries.
You can also use queries in the following ways:
- Create dynamic selection sets based on one or more queries.
- Filter the data in a FlexTable using a query. For more information, see Sorting and Filtering FlexTable Data.
- You can use predefined queries in the Network Navigator. See Using the Network Navigator for more details.